SQL для тестировщика

Даны 2 таблицы с названиями orders и products c колонками "order_id", "customer_id", "product_id", "order_date", "quantity" и "product_id", "product_name", "unit_price". Какой из следующих SQL запросов вернет топ-5 покупателей, которые потратили больше всего в категории "Electronics"?

A) SELECT o.customer_id, SUM(o.quantity * p.unit_price) AS total_spent
FROM orders o JOIN products p ON o.product_id = p.product_id
WHERE p.product_name LIKE '%Electronics%'
GROUP BY o.customer_id
ORDER BY total_spent DESC
LIMIT 5;

B) SELECT o.customer_id, SUM(o.quantity * p.unit_price) AS total_spent
FROM orders o JOIN products p ON o.product_id = p.product_id
WHERE p.product_id IN (SELECT product_id FROM products WHERE product_name LIKE '%Electronics%')
GROUP BY o.customer_id
ORDER BY total_spent DESC
LIMIT 5;

C) SELECT o.customer_id, SUM(o.quantity * p.unit_price) AS total_spent
FROM orders o JOIN products p ON o.product_id = p.product_id
WHERE p.product_id IN (SELECT product_id FROM products WHERE product_name LIKE 'Electronics%')
GROUP BY o.customer_id
ORDER BY total_spent DESC
LIMIT 5;

D) SELECT o.customer_id, SUM(o.quantity * p.unit_price) AS total_spent
FROM orders o JOIN products p ON o.product_id = p.product_id
WHERE p.product_id IN (SELECT product_id FROM products WHERE product_name = 'Electronics')
GROUP BY o.customer_id
ORDER BY total_spent DESC
LIMIT 5;

Ответить на вопрос можно ниже ⬇️

www.tg-me.com/de/SQL для тестировщика/com.sql_for_qa/164

1.4K viewsAug 14, 2023 at 11:30

Даны 2 таблицы с названиями orders и products c колонками "order_id", "customer_id", "product_id", "order_date", "quantity" и "product_id", "product_name", "unit_price". Какой из следующих SQL запросов вернет топ-5 покупателей, которые потратили больше всего в категории "Electronics"?

A) SELECT o.customer_id, SUM(o.quantity * p.unit_price) AS total_spent
FROM orders o JOIN products p ON o.product_id = p.product_id
WHERE p.product_name LIKE '%Electronics%'
GROUP BY o.customer_id
ORDER BY total_spent DESC
LIMIT 5;

B) SELECT o.customer_id, SUM(o.quantity * p.unit_price) AS total_spent
FROM orders o JOIN products p ON o.product_id = p.product_id
WHERE p.product_id IN (SELECT product_id FROM products WHERE product_name LIKE '%Electronics%')
GROUP BY o.customer_id
ORDER BY total_spent DESC
LIMIT 5;

C) SELECT o.customer_id, SUM(o.quantity * p.unit_price) AS total_spent
FROM orders o JOIN products p ON o.product_id = p.product_id
WHERE p.product_id IN (SELECT product_id FROM products WHERE product_name LIKE 'Electronics%')
GROUP BY o.customer_id
ORDER BY total_spent DESC
LIMIT 5;

D) SELECT o.customer_id, SUM(o.quantity * p.unit_price) AS total_spent
FROM orders o JOIN products p ON o.product_id = p.product_id
WHERE p.product_id IN (SELECT product_id FROM products WHERE product_name = 'Electronics')
GROUP BY o.customer_id
ORDER BY total_spent DESC
LIMIT 5;

Ответить на вопрос можно ниже ⬇️

BY SQL для тестировщика